package com.lagou.dao;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Component;

@Mapper
@Component
public interface SysRegionDao {

    /*
       插入sys_region信息
    */
    @Insert("insert into sys_region (region_name,region_code,region_level) values(#{regionName},#{regionCode},#{regionLevel})")
    public int insertSysRegion(@Param("regionName") String regionName, @Param("regionCode") String regionCode, @Param("regionLevel") Integer regionLevel);

    /*
        删除sys_region信息
     */
    @Delete("delete from sys_region where id = #{id}")
    public int deleteSysRegion(@Param("id") Long id);
}
